<?php
try {
    
        ##################### 
        //CONFIGURATIONS  
        #####################
        // Define the name of the backup directory
        define('BACKUP_DIR', './myBackups' ) ; 
        // Define  Database Credentials
        define('HOST', 'localhost' ) ; 
        define('USER', 'root' ) ; 
        define('PASSWORD', '' ) ; 
        define('DB_NAME', 'pyaf_symfony' ) ; 
        /*
        Define the filename for the sql file
        If you plan to upload the  file to Amazon's S3 service , use only lower-case letters 
        */
        $fileName = 'mysqlbackup--' . date('d-m-Y') . '@'.date('h.i.s').'.sql' ; 
        // Set execution time limit
        if(function_exists('max_execution_time')) {
        if( ini_get('max_execution_time') > 0 ) 	set_time_limit(0) ;
        }

        ###########################  

        //END  OF  CONFIGURATIONS  

        ###########################

        // Check if directory is already created and has the proper permissions
        if (!file_exists(BACKUP_DIR)) mkdir(BACKUP_DIR , 0700) ;
        if (!is_writable(BACKUP_DIR)) chmod(BACKUP_DIR , 0700) ; 

        // Create an ".htaccess" file , it will restrict direct accss to the backup-directory . 
        $content = 'deny from all' ; 
        $file = new SplFileObject(BACKUP_DIR . '/.htaccess', "w") ;
        $file->fwrite($content) ;

        $mysqli = new mysqli(HOST , USER , PASSWORD , DB_NAME) ;
        $mysqli->set_charset("utf8");
        if (mysqli_connect_errno())
        {
           printf("Connect failed: %s", mysqli_connect_error());
           exit();
        }
         // Introduction information
        $return = "";
        $return .= "--\n";
        $return .= "-- A Mysql Backup System \n";
        $return .= "--\n";
        $return .= '-- Export created: ' . date("Y/m/d") . ' on ' . date("h:i") . "\n\n\n";
        $return = "--\n";
        $return .= "-- Database : " . DB_NAME . "\n";
        $return .= "--\n";
        $return .= "-- --------------------------------------------------\n";
        $return .= "-- ---------------------------------------------------\n";
        $return .= 'SET AUTOCOMMIT = 0 ;' ."\n" ;
        $return .= 'SET FOREIGN_KEY_CHECKS=0 ;' ."\n" ;
        $tables = array() ; 
        // Exploring what tables this database has
        $result = $mysqli->query('SHOW TABLES' ) ; 
        // Cycle through "$result" and put content into an array
        while ($row = $result->fetch_row()) 
        {
        $tables[] = $row[0] ;
        }
        // Cycle through each  table
         foreach($tables as $table)
         { 
        // Get content of each table
        $result = $mysqli->query('SELECT * FROM '. $table) ; 
        // Get number of fields (columns) of each table
        $num_fields = $mysqli->field_count  ;
        // Add table information
        $return .= "--\n" ;
        $return .= '-- Tabel structure for table `' . $table . '`' . "\n" ;
        $return .= "--\n" ;
        $return.= 'DROP TABLE  IF EXISTS `'.$table.'`;' . "\n" ; 
        // Get the table-shema
        $shema = $mysqli->query('SHOW CREATE TABLE '.$table) ;
        // Extract table shema 
        $tableshema = $shema->fetch_row() ; 
        // Append table-shema into code
        $return.= $tableshema[1].";" . "\n\n" ; 
        // Cycle through each table-row
        while($rowdata = $result->fetch_row()) 
        { 
        // Prepare code that will insert data into table 
        $return .= 'INSERT INTO `'.$table .'`  VALUES ( '  ;
        // Extract data of each row 
        for($i=0; $i<$num_fields; $i++)
        {
        $return .= '"'.$rowdata[$i] . "\"," ;
         }
         // Let's remove the last comma 
         $return = substr("$return", 0, -1) ; 
         $return .= ");" ."\n" ;
         } 
         $return .= "\n\n" ; 
        }
        // Close the connection
        $mysqli->close() ;
        $return .= 'SET FOREIGN_KEY_CHECKS = 1 ; '  . "\n" ; 
        $return .= 'COMMIT ; '  . "\n" ;
        $return .= 'SET AUTOCOMMIT = 1 ; ' . "\n"  ; 
        //$file = file_put_contents($fileName , $return) ; 
        $zip = new ZipArchive() ;
        $resOpen = $zip->open(BACKUP_DIR . '/' .$fileName.".zip" , ZIPARCHIVE::CREATE) ;
        if( $resOpen ){
        $zip->addFromString( $fileName , "$return" ) ;
            }
        $zip->close() ;
        $fileSize = get_file_size_unit(filesize(BACKUP_DIR . "/". $fileName . '.zip')) ; 
        $fileNameUbication = BACKUP_DIR . "/". $fileName . '.zip';
        
        downloadFile($fileNameUbication);
        unlink($fileNameUbication);
        
        echo "true";
        
    } catch (Exception $exc) {
    echo "false";
} 


    // Function to append proper Unit after file-size . 
    function get_file_size_unit($file_size){
        switch (true) {
            case ($file_size/1024 < 1) :
                return intval($file_size ) ." Bytes" ;
                break;
            case ($file_size/1024 >= 1 && $file_size/(1024*1024) < 1)  :
                return intval($file_size/1024) ." KB" ;
                break;
                default:
                return intval($file_size/(1024*1024)) ." MB" ;
        }
    }

    function downloadFile( $fullPath ){ 

      // Must be fresh start 
      if( headers_sent() ) 
        die('Headers Sent'); 

      // Required for some browsers 
      if(ini_get('zlib.output_compression')) 
        ini_set('zlib.output_compression', 'Off'); 

      // File Exists? 
      if( file_exists($fullPath) ){ 

        // Parse Info / Get Extension 
        $fsize = filesize($fullPath); 
        $path_parts = pathinfo($fullPath); 
        $ext = strtolower($path_parts["extension"]); 

        // Determine Content Type 
        switch ($ext) { 
          case "pdf": $ctype="application/pdf"; break; 
          case "exe": $ctype="application/octet-stream"; break; 
          case "zip": $ctype="application/zip"; break; 
          case "doc": $ctype="application/msword"; break; 
          case "xls": $ctype="application/vnd.ms-excel"; break; 
          case "ppt": $ctype="application/vnd.ms-powerpoint"; break; 
          case "gif": $ctype="image/gif"; break; 
          case "png": $ctype="image/png"; break; 
          case "jpeg": 
          case "jpg": $ctype="image/jpg"; break; 
          default: $ctype="application/force-download"; 
        } 

        header("Pragma: public"); // required 
        header("Expires: 0"); 
        header("Cache-Control: must-revalidate, post-check=0, pre-check=0"); 
        header("Cache-Control: private",false); // required for certain browsers 
        header("Content-Type: $ctype"); 
        header("Content-Disposition: attachment; filename=\"".basename($fullPath)."\";" ); 
        header("Content-Transfer-Encoding: binary"); 
        header("Content-Length: ".$fsize); 
        ob_clean(); 
        flush(); 
        readfile( $fullPath ); 

      } else 
        die('File Not Found'); 

    } 



